
import { useEntityManager } from '@sker/core';
import { z } from 'zod';
export default async ()=>{
    const input = z.object({
        uuid: z.string()
    })
    const hour = new Date().getHours()
    await useEntityManager(async (m)=>{
        await m.query(`select min_room.user_id as user_id from (select * from ks_live_room as room where room.max_count > 100 and EXTRACT(HOUR FROM room.open_time::timestamp) = ${hour}) as min_room group by min_room.user_id limit 100`)
    })
    // select min_room.user_id as user_id from (select * from ks_live_room as room where room.max_count > 100 and EXTRACT(HOUR FROM room.open_time::timestamp) = 9) as min_room group by min_room.user_id limit 100
}
